Data Prep 3: Cuddly Stuffed Animals Join

Price: $ 14.99



This case scenario involves sales of cuddly stuffed animals. It can be used in general business or accounting courses. The students extract a sheet from an Excel workbook. They first transform the data as explained in the single stream. Each additional stream is then extracted from the Excel workbook. Then, in addition to the steps used to clean the first stream, they may have to separate a combined field into two separate fields and create new fields. Streams are joined and errors if any must be corrected. One of the streams is a crosstab that must be transformed to a flat data stream with a unique primary key before it can be joined. Then the students load the file back into the Excel file and answer analytical questions related to their unique data. The case can be solved using Alteryx, Power BI or Tableau and a free mini tutorial and data set is available.

Table of contents

View chapter in pdf form

View chapter in ppt form

The book comes with a quizzing system, with each student being presented with a timed quiz comprising five questions selected at random from the database of quiz questions for the chapter. Instructors can assign these quizzes in advance of the topics to be covered in class, giving students an incentive to read the chapter in advance of the class. Students read the chapters and take the online quizzes prior to class.

Each chapter features hyperlinks to related information, taking advantage of the online nature of the book. Additionally, the chapters featuring Microsoft Access databases permit the databases to be downloaded by students for further exploration.

The following are some of the resources available for adopting instructors:

  • Solutions to end-of-chapter questions and problems
  • The ability to make selected solutions available to students
  • The ability to view all quiz questions for a chapter
  • The ability to generate quiz grade reports
  • Sample tests
  • Powerpoint files for each chapter

Videos Demo

Other products


E-Books

No Image Available.
No Image Available.
No Image Available.

Analytics Products

No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.
No Image Available.

Excel Accounting Practice Sets

No Image Available.
No Image Available.
No Image Available.
No Image Available.